IMG
Loading..
Select a color
New Dimension Poplin Long Sleeve Shirt
Item: 8HR-HS1169
Brand: Horace Small

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
Our New Dimension Shirts combine aggressive styling with performance features such as stretch poplin and twill fabrics and silicone permanent creases. Added length to sides helps to keep shirts tucked. Due to the poly-cotton fabric blend, these shirts not only perform all year, but are extremely comfortable and easy to maintain.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '8HR-HS1169') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`